package com.moleq.db;

public class DatabaseSchema {

	public final class ItemSetting {

		public static final String SCHEMA_NAME 				= "t_item_setting";
		public static final String ITEM_UPC 				= "F01";
		public static final String DESCRIPTOR 				= "F02";
		public static final String DEPARTMENT_NUMBER 		= "F03";
		public static final String SUB_DEPARTMENT_NUMBER 	= "F04";
		public static final String ITEM_STATUS_INDICATOR 	= "F08";
		public static final String CASE_PACK_SIZE 			= "F19";
		public static final String UNIT_OF_MEASURE 			= "F23";
		public static final String UNIT_PRICE_FACTOR 		= "F24";
		public static final String VENDOR_NUMBER 			= "F27";
		public static final String EXPANDED_DESCRIPTION 	= "F29";
		public static final String UNIT_PRICE 				= "F30";
		public static final String CURRENT_PRICE_QTY        = "F31";
		public static final String CASE_COST 				= "F38";
		public static final String FOOD_STAMP 				= "F79";
		public static final String TAX1 					= "F81";
		public static final String SCALE_OR_WEIGHT 			= "F82";
		public static final String WIC_ELIGIBLE				= "F178";
		public static final String CVV_ELIGIBILITY			= "F924";
		public static final String CREATE_DATETIME          = "create_datetime";
		public static final String UPDATE_DATETIME          = "update_datetime";
		public static final String FOLLOW_DEPARTMENT		= "F106";
		public static final String TAX2						= "F96";
		public static final String TAX3						= "F97";
		public static final String TAX4						= "F98";
		public static final String ITEM_DISCOUNT_FLAG		= "F150";
		public static final String BOTTLE_DEPOSIT			= "F158";
		public static final String IS_LOYALTY				= "is_loyalty";
		public static final String IS_TARE					= "is_tare";
		public static final String IS_AGE_VER  				= "is_age_ver";
		public static final String TAX5						= "F99";
		public static final String TAX6						= "F100";
		public static final String IS_COUPON				= "is_coupon";
		public static final String SERVICE_FL				= "service_fl";
		public static final String PRINTER_ID				= "printer_id";
		public static final String IS_MULT_COUPON			= "is_mult_coupon";
	}
	
	public final class FlipChart{
		public static final String SCHEMA_NAME 				= "t_flip_chart";
		public static final String ID 						= "fc_id";
		public static final String ITEM_UPC  				= "F01";
		public static final String GROUP 					= "fc_group";
		public static final String ORDER 					= "fc_order";
		public static final String CREATE_DATETIME 			= "create_datetime";
		public static final String UPDATE_DATETIME 			= "update_datetime";
	}
	
	//===========code by feng ===================
	
	public final class PriceSetting{
		public static final String SCHEMA_NAME 				= "t_price_setting";
		public static final String ITEM_UPC 				= "F01";
		public static final String PRICE_MULTIPLE 			= "F135";
		public static final String PRICE 					= "F136";
		public static final String STAR_TDATE 				= "F137";
		public static final String STAR_TTIME 				= "F144";
		public static final String END_DATE 				= "F138";
		public static final String END_TIME 				= "F145";
		public static final String PACKAGEPRICE_MULTIPLE 	= "F143";
		public static final String PACKAGE_PRICE 			= "F139";
		public static final String LIMITEDQTY_AMOUNT		= "F147";
		public static final String LIMITEDQTY_PRICE 		= "F148";
		public static final String DISCOUNT_AMOUNT 			= "F111";
		public static final String DISCOUNT_PERCENT 		= "F112";
		public static final String PRICE_MM 				= "F32";
		public static final String CREATE_DATETIME 			= "create_datetime";
		public static final String UPDATE_DATETIME 			= "update_datetime";
	    public static final String DISCOUNT_LINK			= "ps_discnt_link";
	}

	//===========================================
	
	public final class DepartmentSetting{
	
		public static final String SCHEMA_NAME 				= "t_department_setting";
		public static final String DEPARTMENT_NO 			= "F03";
		public static final String DEPARTMENT_NAME 			= "dep_name";
		public static final String DEPARTMENT_TAX1			= "F81";
		public static final String DEPARTMENT_FOOD_STAMP 	= "F79";
		public static final String CREATE_DATETIME 			= "create_datetime";
		public static final String UPDATE_DATETIME 			= "update_datetime";
		public static final String DEPARTMENT_TAX2 			= "F96";
		public static final String DEPARTMENT_TAX3 			= "F97";
		public static final String DEPARTMENT_TAX4 			= "F98";
		public static final String DEPARTMENT_TAX5 			= "F99";
		public static final String DEPARTMENT_TAX6 			= "F100";
		public static final String SCALABLE					= "F82";
		public static final String WIC 						= "F178";
		public static final String NO_DISCOUNT 				= "F150";
		public static final String CVV 						= "F924";
		public static final String DEPARTMENT_GROUP 		= "F263";
		public static final String ds_AGE_VER  				= "ds_age_ver"; 
		
	}
	
	public final class PosSetting{

		public static final String SCHEMA_NAME 				= "t_pos_setting";
		public static final String ID						= "ps_id";
		public static final String STATION 					= "ps_station";
		public static final String OPEN_TIME 				= "ps_open_time";
		public static final String CLOSE_TIME 				= "ps_close_time";
		public static final String TARE_RATE 				= "ps_tare_rate";
		public static final String TARE1_RATE 				= "ps_tax1_rate";
		public static final String TARE2_RATE 				= "ps_tax2_rate";
		public static final String TARE3_RATE 				= "ps_tax3_rate";
		public static final String TARE4_RATE 				= "ps_tax4_rate";
		public static final String FILPCHART_MAX 			= "ps_fc_max";
		public static final String CREATE_DATETIME 			= "create_datetime";
		public static final String UPDATE_DATETIME 			= "update_datetime";
		public static final String PS_WEIGHT_UNIT 			= "ps_weight_unit";
		public static final String PS_DEPOSIT_VALUE 		= "ps_deposit_value";
		public static final String PRICE_DIGITS 			= "ps_price_digits";
		public static final String STORE_NO					= "ps_store_no";
		public static final String CURRENCY_SIGN			= "ps_currency_sign";
		public static final String OUTOFPAPER				= "ps_out_of_paper";
		public static final String CALCULATE_WEIGHT			= "ps_calc_weight";
		public static final String CALENDAR_TYPE			= "ps_calendar_type";
		public static final String NORM_UPCE				= "ps_norm_upce";
		public static final String NETWORK_ONOFF			= "ps_network_onoff";
		public static final String SHOW_DESC				= "ps_show_desc";
		public static final String DVR						= "ps_dvr";
		public static final String ZERO_BALN				= "ps_zero_baln";
		public static final String ZERO_PRICE				= "ps_zero_price";
		public static final String FS_TAX_RULE				= "ps_fs_tax_rule";
		public static final String PRCTAG_PRINTER			= "ps_prctag_printer";
		public static final String ROUNDING					= "ps_rounding";
		public static final String PRINT_SERVICE			= "ps_print_service";
		public static final String SIG_HOST					= "ps_sig_host";
		public static final String SIG_LOCAL				= "ps_sig_local";
		public static final String SIG_MIN					= "ps_sig_min";
		public static final String RECEIPT_PNT				= "ps_receipt_pnt";
	}
	
	//===========code by wei ===================
//	public final class Transaction{
//		
//		public static final String SCHEMA_NAME 				= "t_pos_trns";
//		public static final String STATION					= "pt_station";
//		public static final String SALE_ORDER_NO			= "pt_sale_order_no";
//		public static final String CASHIER_NO				= "pt_cashier_no";
//		public static final String ORDER_DATE				= "pt_order_date";
//		public static final String ORDER_TIME				= "pt_order_time";
//		public static final String TOTAL					= "pt_total";
//		public static final String PAY						= "pt_pay";
//		public static final String FS_PAY					= "pt_fs_pay";
//	}
//	
//	public final class Transaction_Detail{
//		public static final String SCHEMA_NAME 				= "t_trn_detail";
//		public static final String STATION		 			= "td_station";
//		public static final String SALE_ORDER_NO 			= "td_sale_order_no";
//		public static final String UPC			 			= "F01";
//	}
//	
//	public final class Transaction_Tender{
//		public static final String SCHEMA_NAME 				= "t_trn_tender";
//		public static final String TYPE		 				= "tt_type";
//		public static final String AMT 						= "tt_amt";
//		public static final String SALE_ORDER_NO 			= "tt_sale_order_no";
//	}
	//==========================================
	
	//===========code by feng===================
	public final class TaxSetting{
		public static final String SCHEMA_NAME 				= "t_tax_setting";
		public static final String TX_NO		 			= "tx_no";
		public static final String TX_RATE 					= "tx_rate";
		public static final String TX_START_AMT			 	= "tx_start_amt";
		public static final String TX_PLUS_ROUND			= "tx_plus_round";
		public static final String TX_VAT			 		= "tx_vat";
		public static final String TX_BY_LINE			 	= "tx_by_line";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}

	public final class BottleSetting{
		public static final String SCHEMA_NAME 				= "t_bottle_setting";
		public static final String BO_NO		 			= "bo_no";
		public static final String BO_DESC					= "bo_desc";
		public static final String BO_AMT			 		= "bo_amt";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String BO_ENVF_FLAG				= "bo_envf_flag";
		public static final String BO_ENVF_AMT 				= "bo_envf_amt";
		public static final String BO_ENVF_TAX1 			= "bo_envf_tax1";
		public static final String BO_ENVF_TAX2 			= "bo_envf_tax2";
		public static final String BO_ENVF_TAX3				= "bo_envf_tax3";
		public static final String BO_ENVF_TAX4				= "bo_envf_tax4";
		public static final String BO_ENVF_TAX5 			= "bo_envf_tax5";
		public static final String BO_ENVF_TAX6 			= "bo_envf_tax6";
		public static final String BO_ENVF_FS 				= "bo_envf_fs";
		public static final String BO_ENVF_WIC 				= "bo_envf_wic";
	}
	
	public final class TareSetting{
		public static final String SCHEMA_NAME 				= "t_tare_setting";
		public static final String TA_NO		 			= "ta_no";
		public static final String TA_DESC					= "ta_desc";
		public static final String TA_VALUE			 		= "ta_value";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class ItemTareSetting{
		public static final String SCHEMA_NAME 				= "t_item_tare_setting";
		public static final String IT_NO		 			= "it_no";
		public static final String UPC						= "F01";
		public static final String IT_TARE_NO			 	= "it_tare_no";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class MixMatch{
		public static final String SCHEMA_NAME 				= "t_mix_match";
		public static final String MM_NO		 			= "mm_no";
		public static final String UPC						= "F01";
	}
	
	public final class MixMatchSetting{
		public static final String SCHEMA_NAME 				= "t_mix_match_setting";
		public static final String MS_NO		 			= "ms_no";
		public static final String DESCRIPTION				= "ms_desc";
		public static final String PRICE_MULTIPLE 			= "F135";
		public static final String PRICE 					= "F136";
		public static final String START_DATE 				= "F137";
		public static final String START_TIME 				= "F144";
		public static final String END_DATE 				= "F138";
		public static final String END_TIME 				= "F145";
		public static final String PACKAGEPRICE_MULTIPLE 	= "F143";
		public static final String PACKAGE_PRICE 			= "F139";
		public static final String LIMITEDQTY_AMOUNT		= "F147";
		public static final String LIMITEDQTY_PRICE 		= "F148";
		public static final String DISCOUNT_AMOUNT 			= "F111";
		public static final String DISCOUNT_PERCENT 		= "F112";
		public static final String DISCOUNT_LINK			= "ms_discnt_link";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class PosLineItem{
		public static final String SCHEMA_NAME				= "t_pos_line_items";
		public static final String PL_NO		 			= "pl_no";
		public static final String PL_UPC		 			= "pl_upc";
		public static final String PL_QTY		 			= "pl_qty";
		public static final String PL_WEIGHT		 		= "pl_weight";
		public static final String PL_PRICE		 			= "pl_price";
		public static final String PL_TYPE 					= "pl_type";
	}
	
	public final class FixedTotalRpt{
		public static final String SCHEMA_NAME				= "t_fixed_total_rpt";
		public static final String ID		 				= "ft_id";
		public static final String STORE_ID		 			= "ft_store_id";
		public static final String STATION		 			= "ft_station";
		public static final String DATE		 				= "ft_date";
		public static final String GS_QTY		 			= "ft_gs_qty";
		public static final String GS_AMT		 			= "ft_gs_amt";
		public static final String NS_QTY		 			= "ft_ns_qty";
		public static final String NS_AMT		 			= "ft_ns_amt";
		public static final String CASH_ID		 			= "ft_cash_id";
		public static final String CREDIT_ID		 		= "ft_credit_id";
		public static final String DEBIT_ID	 				= "ft_debit_id";
		public static final String CHECK_ID		 			= "ft_check_id";
		public static final String FOODSTAMP_ID		 		= "ft_foodstamp_id";
		public static final String EBT_ID		 			= "ft_ebt_id";
		public static final String GC_ID		 			= "ft_gc_id";
		public static final String REFUND_QTY		 		= "ft_refund_qty";
		public static final String REFUND_AMT		 		= "ft_refund_amt";
		public static final String TRN_COUNT		 		= "ft_trn_count";
		public static final String AVERAGE		 			= "ft_average";
		public static final String DISCOUNT		 			= "ft_discount";
		public static final String COUPON		 			= "ft_coupon";
		public static final String TAXABLE_1		 		= "ft_taxable_1";
		public static final String TAX_1		 			= "ft_tax_1";
		public static final String TAX_EXEM_1		 		= "ft_tax_exem_1";
		public static final String TAXABLE_2		 		= "ft_taxable_2";
		public static final String TAX_2		 			= "ft_tax_2";
		public static final String TAX_EXEM_2		 		= "ft_tax_exem_2";
		public static final String TAXABLE_3		 		= "ft_taxable_3";
		public static final String TAX_3		 			= "ft_tax_3";
		public static final String TAX_EXEM_3		 		= "ft_tax_exem_3";
		public static final String TAXABLE_4		 		= "ft_taxable_4";
		public static final String TAX_4		 			= "ft_tax_4";
		public static final String TAX_EXEM_4		 		= "ft_tax_exem_4";
		public static final String TAXABLE_5		 		= "ft_taxable_5";
		public static final String TAX_5		 			= "ft_tax_5";
		public static final String TAX_EXEM_5		 		= "ft_tax_exem_5";
		public static final String TAXABLE_6		 		= "ft_taxable_6";
		public static final String TAX_6		 			= "ft_tax_6";
		public static final String TAX_EXEM_6		 		= "ft_tax_exem_6";
		public static final String FT_USER_ID		 		= "ft_user_id";
		public static final String FT_ROUNDING				= "ft_rounding";
		public static final String FT_VDR_COUPON			= "ft_vdr_coupon";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class PinPadSetting{
		public static final String SCHEMA_NAME				= "t_pinpad_setting";
		public static final String PP_NO		 			= "pp_no";
		public static final String PORT		 				= "pp_port";
		public static final String DEVICE_NAME		 		= "pp_device_name";
		public static final String TIME_OUT		 			= "pp_timeout";
		public static final String DEST_IP		 			= "pp_destip";
		public static final String USING		 			= "pp_using";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String SIGNATURE_FL 			= "signature_fl";
		public static final String PP_DEST_PORT 			= "pp_destport";
		public static final String PP_CON_TYPE	 			= "pp_con_type";
	}
	
	public final class PosLineTares{
		public static final String SCHEMA_NAME				= "t_pos_line_tares";
		public static final String LT_ID	 				= "lt_id";
		public static final String LT_LINE_NO		 		= "lt_line_no";
		public static final String LT_TARE_NO		 		= "lt_tare_no";
		public static final String LT_QTY		 			= "lt_qty";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class PosLineDiscnt{
		public static final String SCHEMA_NAME				= "t_pos_line_discnt";
		public static final String LD_ID	 				= "ld_id";
		public static final String LD_LINE_NO		 		= "ld_line_no";
		public static final String LD_DISCNT_NO		 		= "ld_discnt_no";
		public static final String LD_VALUE			 		= "ld_value";
	}
	
	
	public final class PosLineFunc{	
		public static final String SCHEMA_NAME				= "t_pos_line_func";
		public static final String PF_FUNC_ID	 			= "pf_func_id";
		public static final String PF_QTY		 			= "pf_qty";
		public static final String PF_AMT		 			= "pf_amt";
	}
	public final class PosTrns{
		public static final String SCHEMA_NAME				= "t_pos_trns";
		public static final String PT_NO	 				= "pt_no";
		public static final String PT_DATE		 			= "pt_date";
		public static final String PT_STORE_NO		 		= "pt_store_no";
		public static final String PT_STATION		 		= "pt_station";
		public static final String PT_CRT_DATE		 		= "pt_crt_date";
		public static final String PT_CRT_TIME		 		= "pt_crt_time";
		public static final String PT_DONE_DATE		 		= "pt_done_date";
		public static final String PT_DONE_TIME		 		= "pt_done_time";
		public static final String PT_STATUS 				= "pt_status";
		public static final String PT_USER_ID 				= "pt_user_id";
		public static final String PT_TOTAL 				= "pt_total";
		public static final String PT_TAX 					= "pt_tax";
		public static final String PT_TAX_EXEM 				= "pt_tax_exem";
		public static final String PT_CMR_BIRTHDAY 			= "pt_cmr_birthday";
		public static final String PT_TYPE 					= "pt_type";	
		public static final String PT_MANAGER_ID			= "pt_manager_id";
		public static final String PT_APPR					= "pt_appr";
		public static final String PT_ROUNDING_FL			= "pt_rounding_fl";
		public static final String PT_ROUNDING				= "pt_rounding";
	}

	public final class AgeSetting{
		public static final String SCHEMA_NAME				= "t_age_setting";
		public static final String AS_NO	 				= "as_no";
		public static final String AS_DESC		 			= "as_desc";
		public static final String AS_AGE		 			= "as_age";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		
	}
	
	public final class Receipt{
		public static final String SCHEMA_NAME				= "t_receipt_msg";
		public static final String RM_ID	 				= "rm_id";
		public static final String RM_TYPE		 			= "rm_type";
		public static final String RM_MSG		 			= "rm_msg";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String RM_LARGE			 		= "rm_large";
		public static final String RM_JUSTIFY		 		= "rm_justify";
	}
	
	public final class PosEJ{
		public static final String SCHEMA_NAME				= "t_pos_ej";
		public static final String EJ_ID	 				= "ej_id";
		public static final String EJ_NO		 			= "ej_no";
		public static final String EJ_DATE		 			= "ej_date";
		public static final String EJ_CONTENT			 	= "ej_content";
	}
	
	public final class DeptSalesRpt{
		public static final String SCHEMA_NAME				= "t_dept_sales_rpt";
		public static final String DS_ID	 				= "ds_id";
		public static final String DS_STORE_ID	 			= "ds_store_id";
		public static final String DS_STATION		 		= "ds_station";
		public static final String DS_DATE			 		= "ds_date";
		public static final String DS_DEPT	 				= "ds_dept";
		public static final String DS_QTY	 				= "ds_qty";
		public static final String DS_WEIGHT 				= "ds_weight";
		public static final String DS_WT_UNIT 				= "ds_wt_unit";
		public static final String DS_AMT	 				= "ds_amt";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String DS_TYPE	 				= "ds_type";
	}
	
	public final class GroupSalesRpt{
		public static final String SCHEMA_NAME				= "t_group_sales_rpt";
		public static final String GS_ID	 				= "gs_id";
		public static final String GS_STORE_ID	 			= "gs_store_id";
		public static final String GS_STATION		 		= "gs_station";
		public static final String GS_DATE			 		= "gs_date";
		public static final String GS_GROUP	 				= "gs_group";
		public static final String GS_QTY	 				= "gs_qty";
		public static final String GS_WEIGHT 				= "gs_weight";
		public static final String GS_WT_UNIT 				= "gs_wt_unit";
		public static final String GS_AMT	 				= "gs_amt";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class PluSalesRpt{
		public static final String SCHEMA_NAME				= "t_plu_sales_rpt";
		public static final String US_ID	 				= "us_id";
		public static final String US_STORE_ID	 			= "us_store_id";
		public static final String US_STATION		 		= "us_station";
		public static final String US_DATE			 		= "us_date";
		public static final String US_UPC_PLU 				= "us_upc_plu";
		public static final String US_QTY	 				= "us_qty";
		public static final String US_WEIGHT 				= "us_weight";
		public static final String US_WT_UNIT 				= "us_wt_unit";
		public static final String US_AMT	 				= "us_amt";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String US_TYPE	 				= "us_type";
		public static final String US_SUB_DEP 				= "us_sub_dep";
	}

	public final class ItemDiscountSetting{
		public static final String SCHEMA_NAME				= "t_discount_setting";
		public static final String DS_NO	 				= "ds_no";
		public static final String DS_DESC					= "ds_desc";
		public static final String DS_TYPE	 				= "ds_type";
		public static final String DS_VALUE		 			= "ds_value";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String DS_FOLLOW_ITEM 			= "ds_follow_item";
		public static final String DS_TAX1		 			= "ds_tax1";
		public static final String DS_TAX2		 			= "ds_tax2";
		public static final String DS_TAX3		 			= "ds_tax3";
		public static final String DS_TAX4		 			= "ds_tax4";
		public static final String DS_TAX5		 			= "ds_tax5";
		public static final String DS_TAX6		 			= "ds_tax6";
		public static final String DS_FOODSTAMP	 			= "ds_foodstamp";
	}
	
	public final class GLobalDiscountSetting{
		public static final String SCHEMA_NAME				= "t_global_discount_setting";
		public static final String GD_NO	 				= "gd_no";
		public static final String GD_DESC					= "gd_desc";
		public static final String GD_VALUE		 			= "gd_value";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class CouponSetting{
		public static final String SCHEMA_NAME				= "t_coupon_setting";
		public static final String CS_NO	 				= "cs_no";
		public static final String CS_DESC					= "cs_desc";
		public static final String CS_VALUE	 				= "cs_value";
		public static final String CS_LIMIT_QTY		 		= "cs_limit_qty";
		public static final String CS_MIN_PURCHASE		 	= "cs_min_purchase";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class FreeFuncRpt{
		public static final String SCHEMA_NAME				= "t_free_func_rpt";
		public static final String FF_ID	 				= "ff_id";
		public static final String FF_STORE_ID				= "ff_store_id";
		public static final String FF_STATION 				= "ff_station";
		public static final String FF_DATE			 		= "ff_date";
		public static final String FF_FUNC_ID			 	= "ff_func_id";
		public static final String FF_QTY				 	= "ff_qty";
		public static final String FF_AMT				 	= "ff_amt";
		public static final String FF_USER_ID			 	= "ff_user_id";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	
	public final class MultiTareSalesRpt{
		public static final String SCHEMA_NAME				= "t_multi_tare_sales_rpt";
		public static final String MT_ID	 				= "mt_id";
		public static final String MT_STORE_ID				= "mt_store_id";
		public static final String MT_STATION 				= "mt_station";
		public static final String MT_DATE			 		= "mt_date";
		public static final String MT_UPC_PLU			 	= "mt_upc_plu";
		public static final String MT_TARE_NO				= "mt_tare_no";
		public static final String MT_QTY				 	= "mt_qty";		
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
	}
	

	public final class PosTender{
		public static final String SCHEMA_NAME				= "t_pos_tenders";
		public static final String PT_ID	 				= "pt_id";
		public static final String PT_STORE_ID				= "pt_store_id";
		public static final String PT_STATION 				= "pt_station";
		public static final String PT_DATE			 		= "pt_date";
		public static final String PT_SEQ_NO			 	= "pt_seq_no";
		public static final String PT_ONLINE				= "pt_online";
		public static final String PT_FUNCTION			 	= "pt_function";
		public static final String PT_DUE				 	= "pt_due";
		public static final String PT_TENDER				= "pt_tender";
		public static final String PT_CHANGE			 	= "pt_change";
		public static final String PT_REF_NO				= "pt_ref_no";
		public static final String PT_AUTH_CHK			 	= "pt_auth_chk";
		public static final String PT_CARD_TYPE			 	= "pt_card_type";
		public static final String PT_CARD_NO			 	= "pt_card_no";
		public static final String PT_AUTH			 		= "pt_Auth";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String PT_HOST_CODE 			= "pt_host_code";
		public static final String PT_TRN_NO				= "pt_trn_no";
	}
	
	public final class DeptGroup{
		public static final String SCHEMA_NAME				= "t_dept_group";
		public static final String DG_NO	 				= "dg_no";
		public static final String DG_NAME					= "dg_name";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME			 	= "update_datetime";
	}
	
	public final class NetWorkSetting{
		public static final String SCHEMA_NAME				= "t_network_setting";
		public static final String NS_NO	 				= "ns_no";
		public static final String NS_STATION				= "ns_station";
		public static final String NS_NAME					= "ns_name";
		public static final String NS_IP					= "ns_ip";
		public static final String NS_TYPE					= "ns_type";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME			 	= "update_datetime";
	}
	
	public final class SubDeptSetting{
		
		public static final String SCHEMA_NAME 				= "t_sub_dept_setting";
		public static final String SD_ID                    = "sd_id";
		public static final String SD_NAME 					= "sd_name";
		public static final String DEPARTMENT_TAX1			= "F81";
		public static final String DEPARTMENT_FOOD_STAMP 	= "F79";
		public static final String CREATE_DATETIME 			= "create_datetime";
		public static final String UPDATE_DATETIME 			= "update_datetime";
		public static final String DEPARTMENT_TAX2 			= "F96";
		public static final String DEPARTMENT_TAX3 			= "F97";
		public static final String DEPARTMENT_TAX4 			= "F98";
		public static final String DEPARTMENT_TAX5 			= "F99";
		public static final String DEPARTMENT_TAX6 			= "F100";
		public static final String SCALABLE					= "F82";
		public static final String WIC 						= "F178";
		public static final String NO_DISCOUNT 				= "F150";
		public static final String CVV 						= "F924";
		public static final String SD_AGE_VER  				= "sd_age_ver"; 
		public static final String DEPARTMENT_NO 			= "F03";
	}
	//==========================================
	
	
	//===================== Liang =======================
	public final class UserSetting{
		public static final String SCHEMA_NAME				= "t_user_setting";
		public static final String ID						= "us_id";
		public static final String LOGIN_ID                 = "us_login_id";
		public static final String PASSWORD					= "us_pwd";
		public static final String INFO						= "us_info";
		public static final String ACTIVE					= "us_active";
		public static final String COLOR					= "us_color";
		public static final String MANAGER					= "us_manager";
	}
	//===================================================
	
	public final class FreeFunction{
		public static final String SCHEMA_NAME				= "t_free_functions";
		public static final String ID						= "ff_id";
		public static final String Name						= "ff_name";
		public static final String APPR_FL					= "ff_appr_fl"; 
	}
	
	public final class FunctionPanel{
		public static final String SCHEMA_NAME				= "t_function_panel";
		public static final String TP_NO					= "tp_no";
		public static final String TP_ORDER					= "tp_order";
		public static final String TP_FUNC_KEY				= "tp_func_key";
		public static final String TP_LABEL_FILE			= "tp_label_file";
		public static final String TP_APPL_FL				= "tp_appl_fl";
		public static final String TP_PARAMETER1			= "tp_parameter1";
		public static final String TP_PARAMETER2			= "tp_parameter2";
		public static final String CREATE_DATETIME			= "create_datetime";
		public static final String UPDATE_DATETIME			= "update_datetime";
		public static final String TP_PARAMETER3			= "tp_parameter3";
		public static final String TP_LABEL_FILE2			= "tp_label_file2";
	}
	
	public final class PosLineCoupon{
		public static final String SCHEMA_NAME				= "t_pos_line_coupon";
		public static final String LC_ID					= "lc_id";
		public static final String LC_LINE_NO				= "lc_line_no";
		public static final String LC_TYPE					= "lc_type";
		public static final String LC_VALUE					= "lc_value";
	}
	
	public final class StoreSetting{
		public static final String SCHEMA_NAME				= "t_store_setting";
		public static final String SS_ID					= "ss_id";
		public static final String SS_NAME					= "ss_name";
		public static final String SS_OTHER_NAME			= "ss_other_name";
		public static final String SS_ADDRESS_1				= "ss_address_1";
		public static final String SS_ADDRESS_2				= "ss_address_2";
		public static final String SS_CITY					= "ss_city";
		public static final String SS_STATE					= "ss_state";
		public static final String SS_ZIP					= "ss_zip";
		public static final String SS_TELEPHONE				= "ss_telephone";
		public static final String SS_FAX					= "ss_fax";
		public static final String SS_WEBSITE				= "ss_website";
		public static final String CREATE_DATETIME			= "create_datetime";
		public static final String UPDATE_DATETIME			= "update_datetime";
		public static final String SS_BUSINESS_NAME         = "ss_business_name";
	}

	public final class SecuritySetting{
		public static final String SCHEMA_NAME				= "t_security_setting";
		public static final String SC_ID					= "sc_id";
		public static final String SC_USER_ID				= "sc_user_id";
		public static final String SC_FUNC_ID				= "sc_func_id";
	}

	public final class ScannerSetting{
		public static final String SCHEMA_NAME				= "t_scanner_setting";
		public static final String SN_NO					= "sn_no";
		public static final String SN_PORT					= "sn_port";
		public static final String SN_DEVICE_NAME			= "sn_device_name";
		public static final String SN_BAUD					= "sn_baud";
		public static final String SN_PARITY				= "sn_parity";
		public static final String SN_DATA_BITS				= "sn_data_bits";
		public static final String SN_STOP_BITS				= "sn_stop_bits";
		public static final String SN_DISABLE_CMD			= "sn_disable_cmd";
		public static final String SN_ENABLE_CMD			= "sn_enable_cmd";
		public static final String SN_END_CHAR				= "sn_end_char";
		public static final String SN_CHK_DIGIT				= "sn_chk_digit";
		public static final String SN_DATA_FORMAT			= "sn_data_format";
		public static final String SN_WEIGHT_FORMAT			= "sn_weight_format";
		public static final String SN_USING					= "sn_using";
		public static final String CREATE_DATETIME			= "create_datetime";
		public static final String UPDATE_DATETIME			= "update_datetime";
	}
	
	public final class CustomerSetting{
		public static final String SCHEMA_NAME				= "t_customer_setting";
		public static final String CS_NO					= "cs_no";
		public static final String CS_LAST_NAME				= "cs_last_name";
		public static final String CS_FIRST_NAME			= "cs_first_name";
		public static final String CS_ADDRESS_1				= "cs_address_1";
		public static final String CS_ADDRESS_2				= "cs_address_2";
		public static final String CS_CITY					= "cs_city";
		public static final String CS_STATE					= "cs_state";
		public static final String CS_ZIP					= "cs_zip";
		public static final String CS_TELEPHONE				= "cs_telephone";
		public static final String CS_EMAIL					= "cs_email";
		public static final String CREATE_DATETIME			= "create_datetime";
		public static final String UPDATE_DATETIME			= "update_datetime";
	}
	
	public final class ItemPic{
		public static final String SCHEMA_NAME				= "t_item_pic";
		public static final String UPC						= "F01";
		public static final String IP_IMAGE					= "ip_image";
		public static final String IP_IMAGE_SM				= "ip_image_sm";
	}
	
	public final class ItemSales{
		public static final String SCHEMA_NAME				= "t_item_sales";
		public static final String IS_ID 					= "is_id";
		public static final String IS_STORE_ID				= "is_store_id";
		public static final String IS_STATION				= "is_station";
		public static final String IS_TRN_NO				= "is_trn_no";
		public static final String IS_DATE					= "is_date";
		public static final String IS_UPC_PLU				= "is_upc_plu";
		public static final String IS_QTY					= "is_qty";
		public static final String IS_WEIGHT				= "is_weight";
		public static final String IS_WT_UNIT				= "is_wt_unit";
		public static final String IS_AMT					= "is_amt";
	}
	
	public final class InventorySetting{
		public static final String SCHEMA_NAME				= "t_inventory_setting";
		public static final String IS_ID					= "is_id";
		public static final String IS_ONOFF					= "is_onoff";
		public static final String IS_SERVER_IP				= "is_server_ip";
	}
	
	public final class PosLineCvvWic{
		public static final String SCHEMA_NAME				= "t_pos_line_cvvwic";
		public static final String VW_ID					= "vw_id";
		public static final String VW_TYPE					= "vw_type";
		public static final String VW_ACCT_NO				= "vw_acct_no";
		public static final String VW_CHECK_NO				= "vw_check_no";
		public static final String VW_AMOUNT				= "vw_amount";
		public static final String VW_START_DATE			= "vw_start_date";
		public static final String VW_END_DATE				= "vw_end_date";
	}
	
	public final class PrinterSetting{
		public static final String SCHEMA_NAME				= "t_printer_setting";
		public static final String PS_ID					= "ps_id";
		public static final String PS_NAME					= "ps_name";
		public static final String PS_IP					= "ps_ip";
		public static final String PS_PORT					= "ps_port";
	}
	
	public final class RoundingSetting{
		public static final String SCHEMA_NAME				= "t_rounding_setting";
		public static final String RS_ID					= "rs_id";
		public static final String RS_NAME					= "rs_name";
		public static final String RS_DOWN_VALUE			= "rs_down_value";
		public static final String RS_UP_VALUE				= "rs_up_value";
		public static final String RS_TO_VALUE				= "rs_to_value";
		public static final String RS_OPTIONAL				= "rs_optional";
	}
	
	public final class PoslineTender{
		public static final String SCHEMA_NAME				= "t_pos_line_tenders";
		public static final String LT_ID	 				= "lt_id";
		public static final String LT_STORE_ID				= "lt_store_id";
		public static final String LT_STATION 				= "lt_station";
		public static final String LT_DATE			 		= "lt_date";
		public static final String LT_SEQ_NO			 	= "lt_seq_no";
		public static final String LT_ONLINE				= "lt_online";
		public static final String LT_FUNCTION			 	= "lt_function";
		public static final String LT_DUE				 	= "lt_due";
		public static final String LT_TENDER				= "lt_tender";
		public static final String LT_CHANGE			 	= "lt_change";
		public static final String LT_REF_NO				= "lt_ref_no";
		public static final String LT_AUTH_CHK			 	= "lt_auth_chk";
		public static final String LT_CARD_TYPE			 	= "lt_card_type";
		public static final String LT_CARD_NO			 	= "lt_card_no";
		public static final String LT_AUTH			 		= "lt_auth";
		public static final String LT_HOST_CODE             = "lt_host_code";
		public static final String CREATE_TIME 				= "create_datetime";
		public static final String UPDATE_TIME 				= "update_datetime";
		public static final String LT_TRN_NO 				= "lt_trn_no";
	}
	
	public final class VdrCoupon{
		public static final String SCHEMA_NAME				= "t_vdr_coupon_value";
		public static final String CV_CODE_NO	 			= "cv_code_no";
		public static final String CV_DESC					= "cv_desc";
		public static final String CV_MIN_QTY 				= "cv_min_qty";
		public static final String CV_MORE_FL			 	= "cv_more_fl";
		public static final String CV_FREE_QTY			 	= "cv_free_qty";
		public static final String CV_VALUE					= "cv_value";
	}
	
	public final class DvrSetting{
		public static final String SCHEMA_NAME				= "t_dvr_setting";
		public static final String DS_ID					= "ds_id";
		public static final String DS_ONOFF					= "ds_onoff";
		public static final String DS_DVR_IP				= "ds_dvr_ip";
		public static final String DS_PORT 					= "ds_port";
	}
	
	public final class TenderSignature{
		public static final String SCHEMA_NAME				= "t_tender_signature";
		public static final String TS_ID					= "ts_id";
		public static final String TS_TENDER_ID				= "ts_tender_id";
		public static final String TS_SIGNATURE_VALUE		= "ts_signature_value";
		public static final String TS_TRN_NO				= "ts_trn_no";
	}
	
	public final class MultCouponSetting{
		public static final String SCHEMA_NAME 				= "t_mult_cpn_setting";
		public static final String MC_ID 					= "mc_id";
		public static final String MC_ACTIVE  				= "mc_active";
		public static final String MC_CPN_NAME				= "mc_cpn_name";
		public static final String MC_MULT 					= "mc_mult";
		public static final String MC_ADD_VALUE 			= "mc_add_value";
		public static final String MC_MAX_VALUE 			= "mc_max_value";
		public static final String MC_MAX_TOTAL 			= "mc_max_total";
		public static final String CREATE_DATETIME			= "create_datetime";
		public static final String UPDATE_DATETIME			= "update_datetime";
	}
	
	
	//
	public final class RegKey{
		public static final String SCHEMA_NAME 				= "t_reg_key";
		public static final String RK_CODE 					= "rk_code";
		public static final String RK_KEY  					= "rk_key";
		
	}
}
